﻿




DROP TABLE IF EXISTS `open_tb_app`;
CREATE TABLE `open_tb_app` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `app_key` varchar(255) DEFAULT NULL,
  `app_secret` varchar(255) DEFAULT NULL,
  `app_session` varchar(255) DEFAULT NULL,
  `app_name` varchar(255) DEFAULT NULL,
  `shop_name` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `is_use` int(11) DEFAULT '0',
  `field1` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_area`;
CREATE TABLE `open_tb_area` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` varchar(255) DEFAULT NULL,
  `area_type` varchar(255) DEFAULT NULL,
  `area_name` varchar(255) DEFAULT NULL,
  `parent_id` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3708 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_brand`;
CREATE TABLE `open_tb_brand` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `vid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `brand_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_config`;
CREATE TABLE `open_tb_config` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `code` varchar(30) NOT NULL DEFAULT '',
  `type` varchar(10) NOT NULL DEFAULT '',
  `store_range` varchar(255) NOT NULL DEFAULT '',
  `store_dir` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_guige1`;
CREATE TABLE `open_tb_guige1` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) DEFAULT NULL,
  `pid` varchar(255) DEFAULT NULL,
  `prop_name` varchar(255) DEFAULT NULL,
  `vid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_alias` varchar(255) DEFAULT NULL,
  `is_parent` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `sort_order` varchar(255) DEFAULT NULL,
  `color_code` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=11989 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_guige2`;
CREATE TABLE `open_tb_guige2` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) DEFAULT NULL,
  `pid` varchar(255) DEFAULT NULL,
  `prop_name` varchar(255) DEFAULT NULL,
  `vid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_alias` varchar(255) DEFAULT NULL,
  `is_parent` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `sort_order` varchar(255) DEFAULT NULL,
  `size_code` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4765 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_item`;
CREATE TABLE `open_tb_item` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `iid` varchar(255) DEFAULT NULL,
  `detail_url` varchar(255) DEFAULT NULL COMMENT 'detail_url',
  `num_iid` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `cid` varchar(255) DEFAULT NULL,
  `seller_cids` varchar(255) DEFAULT NULL,
  `props` varchar(255) DEFAULT NULL,
  `input_pids` varchar(255) DEFAULT NULL,
  `input_str` varchar(255) DEFAULT NULL,
  `item_desc` text,
  `pic_path` varchar(255) DEFAULT NULL,
  `num` varchar(255) DEFAULT NULL,
  `valid_thru` varchar(255) DEFAULT NULL,
  `list_time` varchar(255) DEFAULT NULL,
  `stuff_status` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `post_fee` varchar(255) DEFAULT NULL,
  `express_fee` varchar(255) DEFAULT NULL,
  `ems_fee` varchar(255) DEFAULT NULL,
  `has_discount` varchar(255) DEFAULT NULL,
  `freight_payer` varchar(255) DEFAULT NULL,
  `has_invoice` varchar(255) DEFAULT NULL,
  `has_warranty` varchar(255) DEFAULT NULL,
  `has_showcase` varchar(255) DEFAULT NULL,
  `modified` varchar(255) DEFAULT NULL,
  `increment` varchar(255) DEFAULT NULL,
  `auto_repost` varchar(255) DEFAULT NULL,
  `approve_status` varchar(255) DEFAULT NULL,
  `postage_id` varchar(255) DEFAULT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `auction_point` varchar(255) DEFAULT NULL,
  `property_alias` varchar(255) DEFAULT NULL,
  `outer_id` varchar(255) DEFAULT NULL,
  `is_virtural` varchar(255) DEFAULT NULL,
  `is_taobao` varchar(255) DEFAULT NULL,
  `is_ex` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=660 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_itemcat`;
CREATE TABLE `open_tb_itemcat` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) DEFAULT NULL,
  `parent_cid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_parent` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `sort_order` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  `cat_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2962 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_itemimg`;
CREATE TABLE `open_tb_itemimg` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `iid` varchar(255) DEFAULT NULL,
  `itemimg_id` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2126 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_itemprop`;
CREATE TABLE `open_tb_itemprop` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_key_prop` varchar(255) DEFAULT NULL,
  `is_sale_prop` varchar(255) DEFAULT NULL,
  `is_color_prop` varchar(255) DEFAULT NULL,
  `is_enum_prop` varchar(255) DEFAULT NULL,
  `is_input_prop` varchar(255) DEFAULT NULL,
  `is_item_prop` varchar(255) DEFAULT NULL,
  `child_template` varchar(255) DEFAULT NULL,
  `must` varchar(255) DEFAULT NULL,
  `multi` varchar(255) DEFAULT NULL,
  `parent_pid` varchar(255) DEFAULT NULL,
  `parent_vid` varchar(255) DEFAULT NULL,
  `prop_values` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `sort_order` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=16591 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_location`;
CREATE TABLE `open_tb_location` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4917 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_my_shipping`;
CREATE TABLE `open_tb_my_shipping` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` varchar(255) DEFAULT NULL,
  `seller_nick` varchar(255) DEFAULT NULL,
  `buyer_nick` varchar(255) DEFAULT NULL,
  `delivery_start` varchar(255) DEFAULT NULL,
  `delivery_end` varchar(255) DEFAULT NULL,
  `out_sid` varchar(255) DEFAULT NULL,
  `item_title` varchar(255) DEFAULT NULL,
  `receiver_name` varchar(255) DEFAULT NULL,
  `receiver_phone` varchar(255) DEFAULT NULL,
  `receiver_mobile` varchar(255) DEFAULT NULL,
  `receiver_location` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `freight_payer` varchar(255) DEFAULT NULL,
  `seller_confirm` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5707 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_order`;
CREATE TABLE `open_tb_order` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `iid` varchar(255) DEFAULT NULL,
  `sku_id` varchar(255) DEFAULT NULL,
  `sku_properties_name` varchar(255) DEFAULT NULL,
  `item_meal_name` varchar(255) DEFAULT NULL,
  `num` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `pic_path` varchar(255) DEFAULT NULL,
  `seller_nick` varchar(255) DEFAULT NULL,
  `buyer_nick` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `created` varchar(255) DEFAULT NULL,
  `refund_status` varchar(255) DEFAULT NULL,
  `tid` varchar(255) DEFAULT NULL,
  `outer_iid` varchar(255) DEFAULT NULL,
  `outer_sku_id` varchar(255) DEFAULT NULL,
  `total_fee` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `discount_fee` varchar(255) DEFAULT NULL,
  `adjust_fee` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `snapshot_url` varchar(255) DEFAULT NULL,
  `snapshot` varchar(255) DEFAULT NULL,
  `timeout_action_time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=9349 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_postage`;
CREATE TABLE `open_tb_postage` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `postage_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  `created` varchar(255) DEFAULT NULL,
  `modified` varchar(255) DEFAULT NULL,
  `post_price` varchar(255) DEFAULT NULL,
  `post_increase` varchar(255) DEFAULT NULL,
  `express_price` varchar(255) DEFAULT NULL,
  `express_increase` varchar(255) DEFAULT NULL,
  `ems_price` varchar(255) DEFAULT NULL,
  `ems_increase` varchar(255) DEFAULT NULL,
  `postage_mode_list` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_postagemode`;
CREATE TABLE `open_tb_postagemode` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `postage_ id` varchar(255) DEFAULT NULL,
  `postage_mode_id` varchar(255) DEFAULT NULL,
  `postage_mode_type` varchar(255) DEFAULT NULL,
  `dest` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `increase` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_propimg`;
CREATE TABLE `open_tb_propimg` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `iid` varchar(255) DEFAULT NULL,
  `propimg_id` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `properties` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_propvalue`;
CREATE TABLE `open_tb_propvalue` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) DEFAULT NULL,
  `pid` varchar(255) DEFAULT NULL,
  `prop_name` varchar(255) DEFAULT NULL,
  `vid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_alias` varchar(255) DEFAULT NULL,
  `is_parent` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `sort_order` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=29918 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_sellerauthorize`;
CREATE TABLE `open_tb_sellerauthorize` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `item_cats` varchar(255) DEFAULT NULL,
  `brands` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_sellercat`;
CREATE TABLE `open_tb_sellercat` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) DEFAULT NULL,
  `parent_cid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `pict_url` varchar(255) DEFAULT NULL,
  `sort_order` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_shipping`;
CREATE TABLE `open_tb_shipping` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` varchar(255) DEFAULT NULL,
  `company_code` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `field1` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_shop`;
CREATE TABLE `open_tb_shop` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` varchar(255) DEFAULT NULL,
  `cid` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `bulletin` varchar(255) DEFAULT NULL,
  `pic_path` varchar(255) DEFAULT NULL,
  `created` varchar(255) DEFAULT NULL,
  `modified` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_shopcat`;
CREATE TABLE `open_tb_shopcat` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) DEFAULT NULL,
  `parent_cid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_parent` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_sku`;
CREATE TABLE `open_tb_sku` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `iid` varchar(255) DEFAULT NULL COMMENT '',
  `sku_id` varchar(255) DEFAULT NULL COMMENT '',
  `properties` varchar(255) DEFAULT NULL COMMENT '',
  `quantity` varchar(255) DEFAULT NULL COMMENT '',
  `price` varchar(255) DEFAULT NULL COMMENT '',
  `outer_id` varchar(255) DEFAULT NULL COMMENT '',
  `created` varchar(255) DEFAULT NULL COMMENT '',
  `modified` varchar(255) DEFAULT NULL COMMENT '',
  `status` varchar(255) DEFAULT NULL COMMENT '',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_trade`;
CREATE TABLE `open_tb_trade` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `seller_nick` varchar(255) DEFAULT NULL,
  `buyer_nick` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `created` varchar(255) DEFAULT NULL,
  `iid` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `pic_path` varchar(255) DEFAULT NULL,
  `num` varchar(255) DEFAULT NULL,
  `tid` varchar(255) DEFAULT NULL,
  `buyer_message` varchar(255) DEFAULT NULL,
  `sid` varchar(255) DEFAULT NULL,
  `shipping_type` varchar(255) DEFAULT NULL,
  `alipay_no` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `discount_fee` varchar(255) DEFAULT NULL,
  `adjust_fee` varchar(255) DEFAULT NULL,
  `snapshot_url` varchar(255) DEFAULT NULL,
  `snapshot` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `seller_rate` varchar(255) DEFAULT NULL,
  `buyer_rate` varchar(255) DEFAULT NULL,
  `buyer_memo` varchar(255) DEFAULT NULL,
  `seller_memo` varchar(255) DEFAULT NULL,
  `pay_time` varchar(255) DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  `modified` varchar(255) DEFAULT NULL,
  `buyer_obtain_point_fee` varchar(255) DEFAULT NULL,
  `point_fee` varchar(255) DEFAULT NULL,
  `real_point_fee` varchar(255) DEFAULT NULL,
  `total_fee` varchar(255) DEFAULT NULL,
  `post_fee` varchar(255) DEFAULT NULL,
  `buyer_alipay_no` varchar(255) DEFAULT NULL,
  `receiver_name` varchar(255) DEFAULT NULL,
  `receiver_state` varchar(255) DEFAULT NULL,
  `receiver_city` varchar(255) DEFAULT NULL,
  `receiver_district` varchar(255) DEFAULT NULL,
  `receiver_address` varchar(255) DEFAULT NULL,
  `receiver_zip` varchar(255) DEFAULT NULL,
  `receiver_mobile` varchar(255) DEFAULT NULL,
  `receiver_phone` varchar(255) DEFAULT NULL,
  `consign_time` varchar(255) DEFAULT NULL,
  `buyer_email` varchar(255) DEFAULT NULL,
  `commission_fee` varchar(255) DEFAULT NULL,
  `seller_alipay_no` varchar(255) DEFAULT NULL,
  `seller_mobile` varchar(255) DEFAULT NULL,
  `seller_phone` varchar(255) DEFAULT NULL,
  `seller_name` varchar(255) DEFAULT NULL,
  `seller_email` varchar(255) DEFAULT NULL,
  `available_confirm_fee` varchar(255) DEFAULT NULL,
  `has_postFee` varchar(255) DEFAULT NULL,
  `received_payment` varchar(255) DEFAULT NULL,
  `cod_fee` varchar(255) DEFAULT NULL,
  `timeout_action_time` varchar(255) DEFAULT NULL,
  `is_3d` varchar(255) DEFAULT NULL,
  `outer_order_sn` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=8123 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_user`;
CREATE TABLE `open_tb_user` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `buyer_credit` varchar(255) DEFAULT NULL,
  `seller_credit` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `created` varchar(255) DEFAULT NULL,
  `last_visit` varchar(255) DEFAULT NULL,
  `birthday` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `has_more_pic` varchar(255) DEFAULT NULL,
  `item_img_num` varchar(255) DEFAULT NULL,
  `item_img_size` varchar(255) DEFAULT NULL,
  `prop_img_num` varchar(255) DEFAULT NULL,
  `prop_img_size` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `alipay_bind` varchar(255) DEFAULT NULL,
  `consumer_protection` varchar(255) DEFAULT NULL,
  `real_name` varchar(255) DEFAULT NULL,
  `id_card` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `alipay_no` varchar(255) DEFAULT NULL,
  `outer_user_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4997 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_usercredit`;
CREATE TABLE `open_tb_usercredit` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `nick` varchar(255) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `score` varchar(255) DEFAULT NULL,
  `total_num` varchar(255) DEFAULT NULL,
  `good_num` varchar(255) DEFAULT NULL,
  `credit_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=10111 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `open_tb_video`;
CREATE TABLE `open_tb_video` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `iid` varchar(255) DEFAULT NULL,
  `video_id` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `modified` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 
ALTER TABLE `open_brand` ADD `vid` VARCHAR( 255 ) NOT NULL  default ''  
ALTER TABLE `open_category` ADD `cid` VARCHAR( 255 ) NOT NULL  default ''  
ALTER TABLE `open_color` ADD `vid` VARCHAR( 255 ) NOT NULL  default ''  
ALTER TABLE `open_size` ADD `vid` VARCHAR( 255 ) NOT NULL  default ''  
ALTER TABLE `open_season` ADD `vid` VARCHAR( 255 ) NOT NULL  default ''  
ALTER TABLE `open_series` ADD `vid` VARCHAR( 255 ) NOT NULL  default ''

ALTER TABLE `open_admin_log` ADD `type` VARCHAR( 255 ) NOT NULL  default ''   
ALTER TABLE `open_transport` ADD `downfrom`  VARCHAR( 255 )  NOT NULL  default 'ERP' 
ALTER TABLE `open_transport` ADD `act`  VARCHAR( 255 )  NOT NULL  default ''  

ALTER TABLE `open_admin_log`  modify `log_info` text 

